/
Step 1 of 3: Prepare the spreadsheets (csv files)

Step 1 of 3: Prepare the spreadsheets (csv files)

Contacts and Stories are imported into Makerble using spreadsheets saved as csv files.

What is a CSV file?

  • A CSV file (which stands for Comma-Separated Values) is just a simple spreadsheet, saved in a different format.

  • If you have a spreadsheet in Excel or Google Sheets, you can easily create a CSV file - just save your spreadsheet as a ".csv" file instead of the default format. (Excel and Google Sheets both have a dedicated option to save your spreadsheet in this format, as do other spreadsheet software such as Apple Numbers and more).

  • This makes it easy to import your historical data into Makerble.

First time importing into Makerble?

 

Types of content

The image below shows a Contact Profile page.

  • the red box shows content that is created by importing a Contact

  • the purple box shows content that is created by importing a Story with a tagged contact (where in this case, the tagged contact is Abigail Holmes - which is why the stories appear on her Timeline)

 

CSV file formatting requirements

  • Remove any paragraph breaks from the cells in the spreadsheet

  • Remove all empty columns from the spreadsheet. (It is fine for a column to have a header - i.e. title but to not have any information below that; but there cannot be any columns that are completely empty)

  • Remove all empty rows from the spreadsheet

  • Check that the spreadsheet contains no more than 800 rows - if it does, create multiple spreadsheets as they will be imported separately

Instructions for preparing CSV files

Next steps

Related content