Photography CRM: when should Excel give way to better client management?
Lisa
Replacing Excel becomes useful when you can no longer easily find a project's status and its next action. The number of contacts matters less than the connections between enquiries, documents, appointments and galleries. A photography CRM mainly brings continuity to this follow-up, provided you organise the transition carefully.
The real problem starts between the columns
A spreadsheet can hold names, contact details and session dates perfectly well. It becomes less practical when decisive information remains in emails, documents and several online services.
One row says “quote sent”, but the client requested a change yesterday. Another says “gallery delivered”, while album selection is still pending.
The problem is not Excel itself. It is the gap between the spreadsheet summary and the reality of your conversations, particularly when several services are progressing at once.
📁 What a CRM should help you find
A CRM is a customer relationship management tool. For a photographer, its value lies in how easily you can find the context of a person or business and continue their project.
Ask yourself what information you need before replying: contact details, service, document sent, expected payment or relevant gallery. These connections should guide your choice.
On Pelli, you find your clients, galleries and quotes, invoices and contracts on the same platform. You can prepare a document and continue managing the service without finding a separate tool for every stage.
Your website can also feed into client follow-up
Follow-up begins with the first enquiry, not just after booking. If your contact form operates separately, you often have to recreate the contact and copy the project elsewhere.
With your Pelli photography website, contact form enquiries go directly into the CRM and a task captures the message. You can find the contact details and project to prepare your response.
From that enquiry, clarify the client's needs and choose the next action: suggest a conversation, prepare a quote or request further information.
An example: managing several orders from the same business
An estate agency regularly commissions you for shoots. In your spreadsheet, it appears on several rows with different shooting addresses and contacts.
Changing tools becomes useful when you need to quickly find everything relating to the agency, then distinguish ongoing services. You want the commercial context on one side and instructions specific to each shoot on the other.
A centralised client record gives you a shared starting point. Each service retains its documents, useful information and gallery according to the organisation you choose.
You can then respond to a new enquiry with an understanding of the existing relationship. You avoid treating a regular client like a stranger with every message.
✨ Import your contacts and organise the transition
Start with active projects and the information needed to follow them. Clean up duplicates, check contact details and identify what should remain in your archives.
On Pelli, open My clients, then Import: you can upload a CSV or Excel (.xlsx) file with up to 5,000 rows. A CSV template is available to prepare your file.
Importing sends no emails to the contacts. Check the recognised columns, adjust their mappings, then review the summary of contacts to create, existing contacts and entries that cannot be imported before confirming.
Keep existing documents in your archives: importing contacts and transferring quotes, invoices or contracts are separate operations. Start new services in Pelli and keep one place for updates to each active project.
Our article on the role of a photography CRM explains uses to consider beyond a simple address book.
Frequently asked questions
How do you import an Excel client file into Pelli?
In My clients, choose Import and upload your Excel (.xlsx) or CSV file, with a limit of 5,000 rows. You can use the provided CSV template to prepare the data before importing.
What do my contacts receive when I import them?
No emails are sent to contacts during import. You prepare your client database before resuming your usual communications.
Discover Pelli if you want to connect your business management, website and photo delivery.