Bulk import from CSV using software like Excel, Numbers, or Google Sheets to create your spreadsheet.
If you have a large number of projects in your online portfolio and don’t like to enter each piece of information manually, a bulk import from CSV or Excel can help.
You can add photos later or add a photo ID to the Bulk Importer File.
To use the Bulk Importer feature with a CSV file, follow these steps:
- We hope you’ve already installed the GS Projects Pro plugin.
- Now download a sample in Excel / CSV format.
- Prepare your data following separators like pipe (|) or comma (,)
- Add Image ID. Follow the doc for how to get the image ID.
How to get an Image ID to add to the Spreadsheet:
- Go to WordPress Dashboard
- Media > Add New > Select Files to upload images
- After uploading, click on Media > Library
- Click on any image
- A popup will open with attachment details. Check URLs like ur-domain.com/wp-admin/upload.php?item=354
- Here, 354 is the image ID.
Media Library after Uploading the Projects Images
Attachment Details with Image ID
Getting Your Spreadsheet Ready For Import
Creating and formatting your spreadsheet properly is an important first step to importing your data to the GS Projects Plugin.
CSV data to import – part 1
CSV data to import – part 2
Follow the format to prepare the spreadsheet
- Title: Project Name/Title
- Image & Image Gallery: Uploaded attachment ID
- Regular text: Description, Excerpt, Tagline, Client Name, Duration, Popup Media Type, Project Status, Client Review
- Numerical Value: Value, Client Rating
- Date: Start Date, End Date
- Links: URL, Video, Audio
- Comma-separated terms (,): Technologies
Ex: WordPress, React, REST, AJAX - Project Additional Fields: Ex: UI prepared by|fab fa-figma|text|Alex, Lead & Planning|fab fa-accusoft|text|Amanda Swon, Developed by|fab fa-wordpress|text|Antonio
- Note: We’re using the Font Awesome V5 Free icons pack. You can search and find icon codes here.
- Taxonomies: gs-project-category: WordPress, Elementor | gs-project-tag: Blog, Portfolio, WordPress, WordPress Website
Import data to GS Projects Plugin
- Go to GS Projects > Bulk Import
- Click on “Upload CSV File.”
- Select gs-project-bulk-importer.csv and click OPEN
- Data will display, & status will be waiting
- Click on START IMPORTING
- Successful import will display “Done” for each row.
After Uploading Projects CSV File
Data import successful
Note
What happens if I leave some fields empty?
– You can keep any field blank on the spreadsheet if no data is available. In that case, the Project will be added, and the respective field(s) will remain blank.
💡 Pro Tip: Importing Non-Latin Characters (Cyrillic, etc.)
If your bulk import file contains non-Latin characters (like Cyrillic, Greek, or Asian scripts) and they don’t display correctly, make sure to save your CSV file in UTF-8 encoding before importing.
UTF-8 ensures all characters—including special symbols and non-Latin letters—are recognized properly during import.
📝 How to Save Your CSV in UTF-8
Google Sheets
- Open your sheet in Google Sheets.
- Go to File → Download → Comma Separated Values (.csv, current sheet).
- Google Sheets automatically saves in UTF-8, so you’re good to go!
Microsoft Excel (Windows)
- Open your file in Excel.
- Click File → Save As.
- In the “Save as type” dropdown, choose CSV UTF-8 (Comma delimited) (*.csv).
- Save the file and use this version for import.
Microsoft Excel (Mac)
- Open your file in Excel.
- Click File → Save As.
- Choose CSV UTF-8 (Comma delimited) (.csv).
- Save and import.
LibreOffice Calc
- Open your file in LibreOffice Calc.
- Go to File → Save As.
- Check Edit filter settings before saving.
- In the dialog, choose Unicode (UTF-8) as the character set.
- Save and import.