ShareList CSV Checker

What it checks and fixes

• The column title row that ShareList adds when it exports a CSV. Importing it would add the titles as a list item, so the fixed version removes it.
• Rows with more than four fields (text, price, qty, note). This usually means a semicolon inside the text that needs double quotes around it.
• Price or qty values that are not plain numbers.
• Quotes that are never closed, and blank rows (blank rows are removed in the fixed version).
• Text with several lines, which needs the “csv data with quotes” option so the lines stay together as one item.

Changes the tool makes for you are listed under “Changed in the fixed version”. Problems it cannot repair safely are listed separately, and those rows are left exactly as they were so you can edit them yourself.

How to import into ShareList

1. Copy the result from the tool above.
2. In ShareList, open Settings and choose Import data.
3. Choose csv text and paste what you copied.
4. Tick “csv data with quotes” only if an item has several lines. Otherwise leave it unticked.
5. Import into a new list or an existing one. To study it as cards, open the list and switch it to flash card mode.
6. Imported lists show only the text at first. Choose to display the note to see the rest.

Each line becomes one item, in the order text; price; qty; note. See the ShareList FAQ for the full import format.