{"_id":"548a71ebb77bb70b00ac8bf4","project":"548a6e4db77bb70b00ac8bea","__v":16,"user":"548a6e421bd6c40b00f7773a","category":{"_id":"548a71991bd6c40b00f7773d","project":"548a6e4db77bb70b00ac8bea","version":"548a6e4db77bb70b00ac8bed","__v":4,"pages":["548a71bc1bd6c40b00f7773e","548a71ebb77bb70b00ac8bf4","548a7699b77bb70b00ac8c01","548a774a1bd6c40b00f77752"],"sync":{"url":"","isSync":false},"reference":false,"createdAt":"2014-12-12T04:39:53.865Z","from_sync":false,"order":0,"slug":"getting-started","title":"Getting Started"},"version":{"_id":"548a6e4db77bb70b00ac8bed","__v":4,"project":"548a6e4db77bb70b00ac8bea","createdAt":"2014-12-12T04:25:49.960Z","releaseDate":"2014-12-12T04:25:49.960Z","categories":["548a6e4eb77bb70b00ac8bee","548a71991bd6c40b00f7773d","548a71d61bd6c40b00f77740","548a76491bd6c40b00f7774e"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"updates":["5501edc764d596210042dd0d"],"next":{"pages":[],"description":""},"createdAt":"2014-12-12T04:41:15.552Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"try":true,"basic_auth":false,"auth":"never","params":[],"url":""},"isReference":false,"order":1,"body":"**What is CSV? **\n\nA CSV is a comma separated values file, which allows data to be saved in a table structured format. CSVs look like a regular spreadsheet but with a .csv extension (Traditionally they take the form of a text file containing information separated by commas, hence the name).\n\nCSV importing and editing allows you to create redirects in bulk. This process which could take several hours if you have to manage thousands makes it quick and efficient. \n\n**How do I edit a CSV file? **\n\nYou can edit a CSV file using common spreadsheet programs such as [Microsoft Excel](https://office.live.com/start/Excel.aspx), [Numbers for Mac](https://www.apple.com/mac/numbers/), or [Google Sheets](https://docs.google.com/spreadsheets/u/0/).\n\n**CSV Structure: ** \n[block:code]\n{\n  \"codes\": [\n    {\n      \"code\": \"path,target\\n/oldpath/,/newtarget/\",\n      \"language\": \"text\"\n    }\n  ]\n}\n[/block]\n[Download a sample CSV file](https://transportr.io/assets/redirect-sample.csv) \n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Editing existing redirects with CSV\"\n}\n[/block]\nTo edit existing redirects, simply export your redirects by choosing \"Export\" from the CSV drop down on the redirects page. This will create a CSV file which you can download that contains an additional \"id\" column. This value is the Shopify redirect ID. If this column exists and it is a valid value, it will edit the row in the CSV file.","excerpt":"","slug":"csv-importing","type":"basic","title":"CSV Importing"}
**What is CSV? ** A CSV is a comma separated values file, which allows data to be saved in a table structured format. CSVs look like a regular spreadsheet but with a .csv extension (Traditionally they take the form of a text file containing information separated by commas, hence the name). CSV importing and editing allows you to create redirects in bulk. This process which could take several hours if you have to manage thousands makes it quick and efficient. **How do I edit a CSV file? ** You can edit a CSV file using common spreadsheet programs such as [Microsoft Excel](https://office.live.com/start/Excel.aspx), [Numbers for Mac](https://www.apple.com/mac/numbers/), or [Google Sheets](https://docs.google.com/spreadsheets/u/0/). **CSV Structure: ** [block:code] { "codes": [ { "code": "path,target\n/oldpath/,/newtarget/", "language": "text" } ] } [/block] [Download a sample CSV file](https://transportr.io/assets/redirect-sample.csv) [block:api-header] { "type": "basic", "title": "Editing existing redirects with CSV" } [/block] To edit existing redirects, simply export your redirects by choosing "Export" from the CSV drop down on the redirects page. This will create a CSV file which you can download that contains an additional "id" column. This value is the Shopify redirect ID. If this column exists and it is a valid value, it will edit the row in the CSV file.